P&I AG

Author

Joseph H

1 Intoduction

Hello, I’m Joseph from Morocco.

Inspired by Hans Rosling’s TED Talk, I taught myself data scraping, analysis, and visualization.
This non-academic approach has given me a unique perspective, as reflected in my projects—though it also means I may require a thorough onboarding process to align with team standards.

I’m open to starting as an intern, either full-time or part-time. Regarding time zones, I’m in UTC+1, but I’m flexible and can adjust my schedule to accommodate the team’s needs.

Feel free to reach me at joseph.ergo@proton.me, and to visit my website for more projects josephelhaddad.github.io.

This custom report, generated from processing 1.4 TB of public data locally, aims to explore the workforce dynamics of a company—up to 2020.
Essentially, I am doing research on a company that does research.

2 About the project

The project came to life after realizing that web scraping doesn’t allow deep-level filtering—without consuming too much time.The irony is, this project itself took me about a month, but the final RDB contains more data than I could ever scrape.

The raw data was 1.4 TB in size and holds information previously scraped.
Processing was done on my local machine using Python, Polars, and DuckDB, following this workflow:
- Processed raw data into structured Parquet files using Polars.
- Transformed each Parquet file into mini RDBs using Polars.
- Merged all mini RDBs into one using DuckDB.
- Analyzed and filtered data to fit the current project.

Alt text Alt text Alt text Alt text

3 EDA

3.1 computer software indestry’s yearly new recruit count

3.2 p&i ag’s workforce status over the years

4 Workforce sample

4.1 Adriano Santagapita

Job title: Sales manager
Associated: False
Socials: https://linkedin.com/in/adriano-santagapita-0b324a5a | https://linkedin.com/in/adriano-a-santagapita-0b324a5a

4.1.1 Adriano Santagapita’s working period at p&i ag

4.1.2 Gantt plot of Adriano Santagapita’s experience


4.2 Amirul Bin Haji Jali

Job title: P and i and marine
Associated: True
Socials: https://linkedin.com/in/amirul-ikwan-bin-haji-jali...

4.2.1 Amirul Bin Haji Jali’s working period at p&i ag

4.2.2 Gantt plot of Amirul Bin Haji Jali’s experience


4.3 Andre Piag

Job title: Softwareentwickler
Associated: True
Socials: https://linkedin.com/in/andre-piag-2860a8136

4.3.1 Andre Piag’s working period at p&i ag

4.3.2 Gantt plot of Andre Piag’s experience


4.4 Andrea Burikova

Job title: Consulting it
Associated: True
Socials: https://linkedin.com/in/andrea-burikova-3634a89

4.4.1 Andrea Burikova’s working period at p&i ag

4.4.2 Gantt plot of Andrea Burikova’s experience


4.5 Andrej Minarik

Job title: Product manager
Associated: True
Socials: https://linkedin.com/in/andrej-minarik-18512b3

4.5.1 Andrej Minarik’s working period at p&i ag

4.5.2 Gantt plot of Andrej Minarik’s experience


4.6 Aurelia Gezynska

Job title: Human resources -sales
Associated: True
Socials: https://linkedin.com/in/aurelia-gezynska-545973b4

4.6.1 Aurelia Gezynska’s working period at p&i ag

4.6.2 Gantt plot of Aurelia Gezynska’s experience


4.7 Brendan Ryan

Job title: Director of development
Associated: True
Socials: https://linkedin.com/in/brendan-ryan-13762a4

4.7.1 Brendan Ryan’s working period at p&i ag

4.7.2 Gantt plot of Brendan Ryan’s experience


4.8 Brigitte Goldmann

Job title: Qualitã tssicherung
Associated: True
Socials: https://linkedin.com/in/brigitte-goldmann-46752a33

4.8.1 Brigitte Goldmann’s working period at p&i ag

4.8.2 Gantt plot of Brigitte Goldmann’s experience


4.9 Christos Triadis

Job title: Geschã ftsfã¼hrer bei p and i ag
Associated: True
Socials: https://linkedin.com/in/christos-triadis-4779bb13

4.9.1 Christos Triadis’s working period at p&i ag

4.9.2 Gantt plot of Christos Triadis’s experience


4.10 David Hippe

Job title: System engineer
Associated: True
Socials: https://linkedin.com/in/david-hippe-1270598 | https://linkedin.com/in/david-hippe-127598

4.10.1 David Hippe’s working period at p&i ag

4.10.2 Gantt plot of David Hippe’s experience


4.11 Denis Schvarcz

Job title: Cee sales
Associated: False
Socials: https://linkedin.com/in/denis-schvarcz-1268571b | https://twitter.com/bohumilstejskal | https://linkedin.com/in/denisschvarcz

4.11.1 Denis Schvarcz’s working period at p&i ag

4.11.2 Gantt plot of Denis Schvarcz’s experience


4.12 Emiliano Paoletti

Job title: Ingegnere
Associated: False
Socials: https://linkedin.com/in/ingemilianopaoletti | https://linkedin.com/in/emiliano-paoletti-250b0a2a

4.12.1 Emiliano Paoletti’s working period at p&i ag

4.12.2 Gantt plot of Emiliano Paoletti’s experience


4.13 Eric Gagnolet

Job title: Sales manager bei p and i ag
Associated: True
Socials: https://linkedin.com/in/eric-gagnolet-56646483

4.13.1 Eric Gagnolet’s working period at p&i ag

4.13.2 Gantt plot of Eric Gagnolet’s experience


4.14 Gerhard Hiebsch

Job title: Software-entwickler
Associated: True
Socials: https://linkedin.com/in/gerhard-hiebsch-70116774

4.14.1 Gerhard Hiebsch’s working period at p&i ag

4.14.2 Gantt plot of Gerhard Hiebsch’s experience


4.15 Guido Blitz

Job title: Sales manager
Associated: True
Socials: https://linkedin.com/in/guido-blitz-baaa6620

4.15.1 Guido Blitz’s working period at p&i ag

4.15.2 Gantt plot of Guido Blitz’s experience


4.16 Herr Scholz

Job title: Key accout manager
Associated: True
Socials: https://linkedin.com/in/herr-scholz-84925386

4.16.1 Herr Scholz’s working period at p&i ag

4.16.2 Gantt plot of Herr Scholz’s experience


4.17 Ioannis Konstantakis

Job title: It
Associated: True
Socials: https://linkedin.com/in/ioannis-konstantakis-a812b632 | https://twitter.com/i_konstantakis | https://linkedin.com/in/ikonstantakis

4.17.1 Ioannis Konstantakis’s working period at p&i ag

4.17.2 Gantt plot of Ioannis Konstantakis’s experience


4.18 Ioannis Triadis

Job title: Senior consultant
Associated: True
Socials: https://linkedin.com/in/ioannis-triadis-28670122

4.18.1 Ioannis Triadis’s working period at p&i ag

4.18.2 Gantt plot of Ioannis Triadis’s experience


4.19 Isabel Mohr

Job title: Senior consultant and projektmanagement
Associated: True
Socials: https://linkedin.com/in/isabel-mohr-743b2a114

4.19.1 Isabel Mohr’s working period at p&i ag

4.19.2 Gantt plot of Isabel Mohr’s experience


4.20 Jean Delgado

Job title: Especialista cmi
Associated: True
Socials: https://linkedin.com/in/jean-carlos-pelallo-delgado...

4.20.1 Jean Delgado’s working period at p&i ag

4.20.2 Gantt plot of Jean Delgado’s experience


4.21 Kai Wagenknecht

Job title: Bereichsleiter
Associated: True
Socials: https://linkedin.com/in/kai-wagenknecht-8b456398

4.21.1 Kai Wagenknecht’s working period at p&i ag

4.21.2 Gantt plot of Kai Wagenknecht’s experience


4.22 Klaus Huyeng

Job title: Sales manager
Associated: True
Socials: https://linkedin.com/in/klaus-huyeng-028b9642

4.22.1 Klaus Huyeng’s working period at p&i ag

4.22.2 Gantt plot of Klaus Huyeng’s experience


4.23 Klaus Warnke

Job title: Programmierer bei p and i ag
Associated: True
Socials: https://linkedin.com/in/klaus-warnke-74125675

4.23.1 Klaus Warnke’s working period at p&i ag

4.23.2 Gantt plot of Klaus Warnke’s experience


4.24 Käthi Seibert

Job title: Sekretã rin
Associated: True
Socials: https://linkedin.com/in/käthi-seibert-13817374

4.24.1 Käthi Seibert’s working period at p&i ag

4.24.2 Gantt plot of Käthi Seibert’s experience


4.25 Laura Seliger

Job title: Sachbearbeiterin auftragsabwicklung
Associated: True
Socials: https://linkedin.com/in/laura-seliger-b68520170

4.25.1 Laura Seliger’s working period at p&i ag

4.25.2 Gantt plot of Laura Seliger’s experience


4.26 Lisa-Marie Weber

Job title: Content-manager
Associated: True
Socials: https://linkedin.com/in/lisa-marie-weber-17336919a

4.26.1 Lisa-Marie Weber’s working period at p&i ag

4.26.2 Gantt plot of Lisa-Marie Weber’s experience


4.27 Lol Bol

Job title: Electrician
Associated: True
Socials: https://linkedin.com/in/lol-bol-572b27154

4.27.1 Lol Bol’s working period at p&i ag

4.27.2 Gantt plot of Lol Bol’s experience


4.28 Mario Fuchs

Job title: Human resources consultant
Associated: True
Socials: https://linkedin.com/in/mario-fuchs-215583ba

4.28.1 Mario Fuchs’s working period at p&i ag

4.28.2 Gantt plot of Mario Fuchs’s experience


4.29 Martin Fiala

Job title: Consultant
Associated: True
Socials: https://linkedin.com/in/martin-fiala-27a3237a

4.29.1 Martin Fiala’s working period at p&i ag

4.29.2 Gantt plot of Martin Fiala’s experience


4.30 Matej Budzel

Job title: Programmer, analyst
Associated: True
Socials: https://linkedin.com/in/matej-budzel-709b5a44

4.30.1 Matej Budzel’s working period at p&i ag

4.30.2 Gantt plot of Matej Budzel’s experience


4.31 Mayritsch Gudrun

Job title: Seminaradministration
Associated: True
Socials: https://linkedin.com/in/mayritsch-gudrun-93a27675

4.31.1 Mayritsch Gudrun’s working period at p&i ag

4.31.2 Gantt plot of Mayritsch Gudrun’s experience


4.32 Michael Gebauer

Job title: Softwareentwickler
Associated: True
Socials: https://linkedin.com/in/michael-gebauer-09426975

4.32.1 Michael Gebauer’s working period at p&i ag

4.32.2 Gantt plot of Michael Gebauer’s experience


4.33 Michael Müller

Job title: Consulting manager pubplic
Associated: True
Socials: https://linkedin.com/in/michael-müller-6b37b5 | https://linkedin.com/in/michael-mã¼ller-6b37b5

4.33.1 Michael Müller’s working period at p&i ag

4.33.2 Gantt plot of Michael Müller’s experience


4.34 Michael Schimmel

Job title: It-manager
Associated: True
Socials: https://linkedin.com/in/michael-schimmel-69472512a

4.34.1 Michael Schimmel’s working period at p&i ag

4.34.2 Gantt plot of Michael Schimmel’s experience


4.35 Milan Hajas

Job title: Developer
Associated: True
Socials: https://linkedin.com/in/milan-hajas-15104a8

4.35.1 Milan Hajas’s working period at p&i ag

4.35.2 Gantt plot of Milan Hajas’s experience


4.36 Milan Kubov

Job title: Pep and time developer and analyst
Associated: True
Socials: https://linkedin.com/in/milan-kubov-4015356

4.36.1 Milan Kubov’s working period at p&i ag

4.36.2 Gantt plot of Milan Kubov’s experience


4.37 Otto Wanner

Job title: Dozent
Associated: False
Socials: https://linkedin.com/in/otto-wanner-1133b2125

4.37.1 Otto Wanner’s working period at p&i ag

4.37.2 Gantt plot of Otto Wanner’s experience


4.38 Paolo Illari

Job title: Selezionatore porno attrici
Associated: True
Socials: https://linkedin.com/in/paolo-illari-554b9426

4.38.1 Paolo Illari’s working period at p&i ag

4.38.2 Gantt plot of Paolo Illari’s experience


4.39 Peggy Gatani

Job title: Sales manager
Associated: True
Socials: https://linkedin.com/in/peggygatani | https://linkedin.com/in/peggy-gatani-70aab325

4.39.1 Peggy Gatani’s working period at p&i ag

4.39.2 Gantt plot of Peggy Gatani’s experience


4.40 Peter Kolarik

Job title: Senior programmer and analyst
Associated: True
Socials: https://linkedin.com/in/peter-kolarik-9b724993 | https://linkedin.com/in/kolarik-peter-9b724993

4.40.1 Peter Kolarik’s working period at p&i ag

4.40.2 Gantt plot of Peter Kolarik’s experience


4.41 Peter Vozar

Job title: Developer
Associated: False
Socials: https://linkedin.com/in/peter-vozar-70940131

4.41.1 Peter Vozar’s working period at p&i ag

4.41.2 Gantt plot of Peter Vozar’s experience


4.42 Ralf Heinemann

Job title: Technical consultant
Associated: True
Socials: https://linkedin.com/in/ralfheinemann | https://linkedin.com/in/ralf-heinemann-bb2527b

4.42.1 Ralf Heinemann’s working period at p&i ag

4.42.2 Gantt plot of Ralf Heinemann’s experience


4.43 Ralf Wallenstein

Job title: Qualitã tssicherung
Associated: True
Socials: https://linkedin.com/in/ralf-wallenstein-b1817a74

4.43.1 Ralf Wallenstein’s working period at p&i ag

4.43.2 Gantt plot of Ralf Wallenstein’s experience


4.44 Ralph Kalinke

Job title: Sales manager
Associated: True
Socials: https://linkedin.com/in/ralph-kalinke-09721582 | https://linkedin.com/in/ralph-kalinke-09735356

4.44.1 Ralph Kalinke’s working period at p&i ag

4.44.2 Gantt plot of Ralph Kalinke’s experience


4.45 Rick Driessen

Job title: Consultant
Associated: False
Socials: https://linkedin.com/in/rick-driessen-42a1857 | https://linkedin.com/in/rickdriessen

4.45.1 Rick Driessen’s working period at p&i ag

4.45.2 Gantt plot of Rick Driessen’s experience


4.46 Sandra Braun

Job title: Qualitã tssicherung
Associated: True
Socials: https://linkedin.com/in/sandra-braun-3443021b2

4.46.1 Sandra Braun’s working period at p&i ag

4.46.2 Gantt plot of Sandra Braun’s experience


4.47 Saskia Van Eesteren

Job title: Marketing and sales
Associated: False
Socials: https://linkedin.com/in/saskia-blom-van-eesteren-a52021b | https://linkedin.com/in/saskia-blom-van-eesteren | https://twitter.com/s_assist

4.47.1 Saskia Van Eesteren’s working period at p&i ag

4.47.2 Gantt plot of Saskia Van Eesteren’s experience


4.48 Simona Zucchi

Job title: Addetto alla logistica
Associated: True
Socials: https://linkedin.com/in/simona-zucchi-b4b399167

4.48.1 Simona Zucchi’s working period at p&i ag

4.48.2 Gantt plot of Simona Zucchi’s experience


4.49 Soenke Bradtmoeller

Job title: Consultant
Associated: False
Socials: https://linkedin.com/in/soenke-bradtmoeller-7410918a

4.49.1 Soenke Bradtmoeller’s working period at p&i ag

4.49.2 Gantt plot of Soenke Bradtmoeller’s experience


4.50 Stefan Herrchen

Job title: Key account manager bei p and i ag
Associated: True
Socials: https://linkedin.com/in/stefan-herrchen-254aa917

4.50.1 Stefan Herrchen’s working period at p&i ag

4.50.2 Gantt plot of Stefan Herrchen’s experience


4.51 Stephanie Schäfer

Job title: Vertriebsinnendienst
Associated: False
Socials: https://linkedin.com/in/stephanie-schäfer-076395b1

4.51.1 Stephanie Schäfer’s working period at p&i ag

4.51.2 Gantt plot of Stephanie Schäfer’s experience


4.52 Takaaki Sato

Job title: Manager technical services
Associated: True
Socials: https://linkedin.com/in/takaaki-sato-5007132a

4.52.1 Takaaki Sato’s working period at p&i ag

4.52.2 Gantt plot of Takaaki Sato’s experience


4.53 Tatjana Medic

Job title: It-consultant bei p and i ag
Associated: True
Socials: https://linkedin.com/in/tatjana-medic-5a49987b

4.53.1 Tatjana Medic’s working period at p&i ag

4.53.2 Gantt plot of Tatjana Medic’s experience


4.54 Tom Heisterbach

Job title: Strategic account manager
Associated: True
Socials: https://linkedin.com/in/tom-heisterbach-8a487050 | https://twitter.com/tomheisterbach

4.54.1 Tom Heisterbach’s working period at p&i ag

4.54.2 Gantt plot of Tom Heisterbach’s experience


4.55 Tristan Vellut

Job title: Senior consultant rh
Associated: True
Socials: https://facebook.com/tristan.vellut | https://linkedin.com/in/tristan-vellut-9a5ab965

4.55.1 Tristan Vellut’s working period at p&i ag

4.55.2 Gantt plot of Tristan Vellut’s experience


4.56 Wilson Northamerica

Job title: Ces
Associated: True
Socials: https://linkedin.com/in/wilson-gutierrez-ces-northamerica-12b1285b

4.56.1 Wilson Northamerica’s working period at p&i ag

4.56.2 Gantt plot of Wilson Northamerica’s experience


4.57 Yngve Johnson

Job title: Kommunikasjonsrã dgiver
Associated: False
Socials: https://linkedin.com/in/yngve-johnson-72a97427

4.57.1 Yngve Johnson’s working period at p&i ag

4.57.2 Gantt plot of Yngve Johnson’s experience


4.58 Zubair Parwany

Job title: Software engineer
Associated: True
Socials: https://linkedin.com/in/zubair-parwany-7431515a | https://linkedin.com/in/zubairparwany

4.58.1 Zubair Parwany’s working period at p&i ag

4.58.2 Gantt plot of Zubair Parwany’s experience


4.59 Zuzana Durfinova

Job title: Product development manager and quality assurance
Associated: True
Socials: https://linkedin.com/in/zuzana-durfinova-94b05b41

4.59.1 Zuzana Durfinova’s working period at p&i ag

4.59.2 Gantt plot of Zuzana Durfinova’s experience


4.60 Zuzana Moncekova

Job title: Human resources and office manager
Associated: True
Socials: https://linkedin.com/in/zuzanamoncekova

4.60.1 Zuzana Moncekova’s working period at p&i ag

4.60.2 Gantt plot of Zuzana Moncekova’s experience